<?php


class Blackbird_Model_Users extends Zend_Db_Table
{
	function fetchFrontPageArticles()
	{
		$db->getAdapter();
		$sql = 'select * from bb_article'
			. "\n	where inFrontPage <> 0 and publishedDate <= CURRENT_TIMESTAMP"
			. "\n		and (expiredDate is null or expiredDate >= CURRENT_TIMESTAMP)"
			;
		return $db->fetchAll($sql);
	}
}

